HomeOrder ManagementBasic featuresAppsAdmin environmentAfosto CMSDevelopers

Warehouse-settings

Afosto offers a powerful bulk action feature to efficiently configure warehouse settings based on SKU.

With this bulk action, you can quickly and easily adjust settings such as:

  • Optimal stock levels
  • Reorder points
  • Backorder statuses

This is essential for streamlined inventory management, especially for businesses managing large quantities of products. Using a bulk action saves time and reduces errors compared to manually updating warehouse settings.

For more information, see our guide: Manage Inventory and Warehouse Settings.

To modify warehouse settings in bulk:

  • Go to Processes and click on Bulk Actions (located in the left-hand main menu).

Next, the following screen will appear. Here, search for the bulk action called “Add Warehouse Settings.”

For efficient use of bulk actions, knowledge of spreadsheets (Google Sheets or Excel) is a plus.

  • The template for the bulk action to create organizations can be downloaded via the “Download Template” button in the platform or via this link: [Google Docs link].
  • The template explains how the spreadsheet should be formatted so you can paste your data or upload a CSV file correctly. Make sure the spreadsheet is properly prepared before continuing with this guide.

Reference

  • When starting the bulk action, give it a reference so you can easily recognize it later.
  • This reference has no other function; you can leave the pre-filled reference as it is.

Select Warehouse and Business

Warehouse

  • In the “In Warehouse” field, select the warehouse where you want to add the stock.
  • This can be your physical store or a warehouse at another location.
  • The stock you add will be registered in the selected warehouse.

Business

  • In the “For business” field, specify which business the stock belongs to, especially if you have multiple companies linked to your Afosto account.
  • This indicates which business owns this stock among the different companies in your account.

Select Data Type

In the second step, you are presented with three options:

  1. Existing dataset: Use this if you have previously uploaded a CSV file and want to reuse it.
  2. Spreadsheet: Use this to quickly paste your data from the template or another spreadsheet.
  3. CSV integration: Use this to upload a new CSV file.

Since the Spreadsheet option is the fastest, we will proceed with option 2 for this guide.

Paste Data

In the next step, you will see a table. Here, you can paste the values from your spreadsheet as shown.

  • Make sure the first row always contains the column names for the data you want to upload.
  • Once the fields are correctly populated, click “Next” to continue.

Verify Data

In the next step, review the entered data carefully.

  • If everything looks correct, confirm your dataset to proceed.
  • If you need to make changes, go back to edit the data before continuing.

Column Selection

In the next step, you need to map the columns from your dataset to the corresponding columns in Afosto.

  • If you used the same column names from the template, the columns will usually be automatically matched, as the system recognizes them.

Validation

Once you click “Next”, the dataset will be validated.

  • If there are no errors, you can click “Execute Bulk Action” to run the bulk action.
  • If the validation fails the first time, it can help to run the validation again immediately.
On this page